create external table spmi_ods.spmi_pcp_piece_bill_face_sum (
    id                         bigint          comment '主键id'  ,
    sync_id                    bigint          comment '同步id(原数据的id)',
    send_network_id            bigint          comment '寄件网点id',
    send_network_name          string          comment '寄件网点名称',
    send_network_code          string          comment '寄件网点编码',
    send_financial_center_id   bigint          comment '寄件财务中心',
    send_financial_center_name string          comment '寄件财务中心名称',
    send_financial_center_code string          comment '寄件财务中心编码',
    bill_generation_date       date            comment '入账日期',
    count_sheet                bigint          comment '电子面单费票数',
    create_date                date            comment '统计日期',
    create_time                timestamp       comment '统计时间',
    count_before               bigint          comment '票数（含2020年运单录入票数）',
    fee_type_id                bigint          comment '费用类型 1 电子面单费 2基础派费',
    fee_type_code              string          comment '费用类型编码',
    fee_sum                    double          comment '费用金额'
)
comment '派件费面单量日汇总统计表'
partitioned by ( dt string comment '运单生成日期 (yyyy-mm-dd)' )
stored as parquet
location '/dw/hive/spmi_ods.db/external/spmi_pcp_piece_bill_face_sum'
tblproperties (
  'parquet.column.index.access'='true'
);